SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460904 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460904 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70942,746395,570729,691548,402712,680251,245420,38208,507743,1002878,51886,365897,381777,754857,978092,262853,1044751,891596,113543,282738,401847,34370,428906,404188,56885,10315,5895,79122,344715,397555,798565,880817,720489,209188,998717,863528,982868,681067,90679,352926,36875,832938,521423,384043,58021,1003801,854817,612936,807770,1037364,836543,296244,855850,100285,923930,762416,653933,201664,339687,456047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]