SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408766 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408766 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385188,539819,1021839,909420,449246,1020252,978812,652379,373219,121300,846695,632322,354470,866152,608206,320028,638904,293741,703518,1031683,691245,258460,372349,256868,268338,492806,637928,194337,12166,1022765,109010,186588,124588,343018,164517,435340,523071,95895,387912,997229,690603,673835,481609,96287,737088,416995,21060,937529,141819,328760,98386,187267,423942,338722,928143,103062,260752,567584,12991,357709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]