SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029047 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029047 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756001,648342,337849,93438,1018646,413883,355080,520328,1017520,309574,688780,241912,474104,735440,149900,201924,794981,523739,628669,5264,994941,689735,909453,403899,315706,354811,809175,765243,85685,763879,215998,1041511,421406,480372,233471,360097,133053,662372,107899,533254,601391,218069,107492,1032776,199220,91372,354536,56365,800095,810794,753702,133942,487123,414209,399155,267614,439561,218551,73454,735552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]