SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58040 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58040 [ RunTime:0.001391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311173,498553,334880,533868,176090,167528,807162,742682,778041,972912,782270,281040,31189,237103,388807,875876,356834,462023,133491,694726,774583,590717,422574,421177,935831,846584,56268,268197,1007162,447060,803173,502430,885255,284435,866794,185539,52559,244822,257363,1046524,844807,102610,155924,128909,733632,654221,89432,1004949,840949,970759,1002960,173334,652836,279123,834566,299261,184180,846228,349698,766403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]