SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485718 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485718 [ RunTime:0.003001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565838,448821,343146,998928,631539,815986,623749,458808,346954,896498,171764,500839,471477,408457,254887,926821,772127,1041853,400712,616168,708387,693210,301416,274891,137972,186301,657807,357830,678653,400077,319755,779836,498900,139235,590460,634434,917749,158790,542262,49600,494244,567094,296593,27430,475710,172796,825931,223043,353507,130896,530169,596280,1045147,658146,362286,358007,249976,650652,917553,582599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001863s ]