SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426412 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426412 [ RunTime:0.006271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848704,208532,86683,997492,789638,809294,1004132,899972,153493,522621,861747,27546,890852,150292,678889,799273,610938,743069,844561,736954,368848,394753,549975,111024,283019,128052,778502,879127,576875,255063,339837,230958,839061,330523,893408,965875,684827,971970,626252,157261,512454,955888,626700,488670,41644,328401,634644,23903,179242,427569,264688,405833,219055,745315,932244,993667,928491,971791,686547,187009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001296s ]