SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428834 LIMIT 1 [ RunTime:0.001136s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428834 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011206,66804,937827,50968,989489,21542,964727,1014867,342932,74866,148019,502393,28152,114830,282702,365408,647535,585261,284890,169419,599748,755871,636815,388712,294606,468991,251489,203244,23695,768411,850684,109042,203249,828615,155017,966651,817002,175270,782527,99927,41428,7894,683280,818516,1044520,924019,804456,638232,267153,608781,790913,850395,247754,604857,926233,919097,740480,282982,945077,430043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002338s ]