SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475853 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475853 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753983,995604,838450,1005686,476660,734045,292576,809825,701778,1031018,616818,10433,335499,612156,685590,795709,1025766,203839,1039251,1013822,556445,916362,184911,388842,920150,543061,596864,984371,243915,986182,312435,840350,277869,126699,278383,527445,484166,775306,631067,960611,896243,688960,563960,959867,269309,129223,888743,843987,372123,928200,139462,448946,526953,985284,512366,408447,345553,414261,1009009,230337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]