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` = 414895 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414895 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153147,512859,402148,318796,791807,531783,525502,281028,413237,205159,335998,104090,471659,508542,553729,818067,19339,47912,935695,622459,899422,933023,464720,370278,902897,7431,451525,230015,787767,592075,1027488,415331,158864,912659,88326,224209,781753,436867,315865,275213,850114,562957,322526,486074,162930,203862,37026,935333,920600,982074,906681,802962,506258,982327,913387,438185,209144,543369,564385,323107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]