SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34697 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34697 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329243,228098,702797,155011,99077,794094,474719,610569,1040205,387830,774260,1012102,97493,766396,991006,237190,440924,68287,391391,831257,477921,916129,771732,190910,984341,860818,382408,787294,924625,636608,176593,143579,310777,43121,209889,454219,174672,261101,402762,387602,525623,476109,27422,19681,574639,455815,328211,826840,1013455,189925,198089,155267,1005056,276810,660073,923638,332076,190497,290371,702543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006916s ]