SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406161 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406161 [ RunTime:0.002901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281752,980854,598477,315530,813905,1047619,255544,982790,688660,561921,961659,442936,986662,45471,796221,309696,805122,760500,926583,734720,900813,131159,113899,327093,84621,767038,702180,338623,48495,678333,202011,356609,799194,130514,570995,1001881,826431,29780,1019637,312100,556853,402035,52405,310404,328453,1017397,674865,453111,1037076,874188,803693,799029,303714,931727,419255,704910,360903,728918,777768,504076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001191s ]