SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48143 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48143 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3599,807356,1021518,126725,252891,297984,887596,279777,708297,491890,258505,713061,362520,594384,643900,58059,111334,866761,989260,909495,521113,994330,134396,721408,229621,953277,826989,539681,746462,283005,741550,806189,1021222,371255,212770,449832,575815,635271,871470,974220,86331,282075,1009113,313046,394898,547116,662386,237195,59766,688767,753343,831157,891837,265174,459959,830939,810837,895368,831616,70469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]