SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041906 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041906 [ RunTime:0.003556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20844,244359,782571,807548,13385,987781,2199,920299,543786,340877,59377,617643,145406,456042,359412,904636,509865,947433,14342,38526,294777,517971,103497,672144,114479,170333,516300,731560,100816,752765,165813,955092,5523,40178,514147,131763,438590,407644,590264,391354,64171,886795,731131,177918,329334,590478,131123,279579,7359,753425,644107,131664,614087,101367,355409,439782,901188,87149,200710,158355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]