SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972820 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972820 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011247,168200,362586,186722,575438,143717,1017758,699699,218991,227580,801622,180661,292293,678597,518562,646915,941523,923782,37313,738186,360292,276724,859229,441114,117873,197411,490164,765022,929914,195829,331507,940508,763140,157280,90429,858173,87453,957309,1021735,27850,376746,794542,390498,171661,678147,848833,953463,853220,920229,363842,538578,585806,84389,162809,847733,45362,1012456,312254,424063,35169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]