SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428509 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428509 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405201,102230,297789,119695,169255,845917,120696,277554,786861,211916,1012553,825557,610664,254454,585100,913332,919062,674388,189051,397539,514838,500902,387601,822501,320920,569697,588199,989287,420876,163629,138464,272548,622546,981163,372782,53367,865673,989879,777953,791676,393144,105670,44650,318653,828420,357355,332792,832021,986725,791553,609832,161753,127816,917525,888906,851677,494109,312612,402937,629992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002585s ]