SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539316 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539316 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657626,430983,987814,352881,90834,830578,346422,307831,545331,684733,673916,76169,816285,710430,919277,458903,628851,231793,603959,740317,877555,539925,888289,904046,513760,314242,251091,959601,976273,879119,219411,209096,650073,332699,884980,450810,378339,311426,841013,910894,227992,72692,80137,640738,450488,276396,600653,523549,684980,497243,474733,668242,811561,366983,625686,826863,668982,997634,748919,864076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]