SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804152 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804152 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109275,302737,737464,963753,800861,601453,385138,396805,36609,741267,134761,915041,927271,236149,840086,1029274,650898,588981,196743,412609,431506,751729,654641,585961,631191,656770,815645,1037120,195521,491922,41111,110967,1005997,777912,870796,60028,624044,233736,323497,442180,591023,230626,336650,151430,500270,672380,619825,900659,628932,1042968,87600,875355,631288,985204,889959,999834,440483,952200,1029502,848703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]