SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541935 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541935 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454602,641410,1022786,410847,49537,376929,349488,1037346,393407,392726,906128,896375,746305,985446,355055,369512,38744,933007,575027,439792,550490,34789,504024,498927,199361,86375,175960,619204,168978,320638,842104,31368,80371,561548,888041,356098,462354,100567,37430,507796,842219,932922,884881,967433,1042917,766969,54114,97207,464450,1038535,680019,453786,321285,303337,675019,436623,385135,389001,205007,63446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]