SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397991 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397991 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509859,372179,858570,407245,551240,418548,475862,253852,1043235,194645,420618,795941,392437,257230,637198,48529,661806,185731,383666,748622,126762,789589,853925,274285,966211,810118,660530,328993,452021,246548,745340,7955,448390,1003940,178290,480357,952140,187963,666184,467573,620942,680109,393414,852367,521965,120389,78266,784938,910387,730939,478900,720790,673615,153492,380307,469752,169016,610388,336485,962953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]