SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508798 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508798 [ RunTime:0.004831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444326,275836,808716,386914,612947,307236,204736,994073,1007779,864353,439983,752135,839751,768788,386686,8634,477149,1003363,747815,850528,809282,18057,244558,135793,60581,384061,764983,247848,272420,275296,629120,404259,478438,461582,73830,1020852,136339,110718,40474,389563,919636,169841,574046,1010268,237294,557959,590987,736107,544443,396864,893935,583891,591172,402522,884381,572845,120661,904868,969562,882861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]