SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502890 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502890 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141741,450232,460916,610300,566073,402793,566902,614398,904378,480179,755513,699450,914916,5918,636014,551404,64235,473299,963932,189356,184931,360965,25007,154458,690644,772333,206876,823260,620482,151650,705278,584953,759888,722181,707945,753546,171867,248665,432991,97903,335377,490807,242707,562029,172703,445096,729723,171262,280220,1012786,286459,898473,603542,73313,523208,44235,862827,868454,199088,873194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]