SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400299 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400299 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483840,243537,820608,595718,292878,203672,570570,539933,882822,174871,909124,876721,514629,954904,222148,509152,865815,838805,548763,974427,258823,266598,401106,112673,354385,577632,510520,409543,530658,990742,967015,767581,975802,891775,999003,589484,632064,798973,141397,348431,292880,920459,743834,803885,868126,443841,938211,745847,492062,950780,591780,772103,840570,702619,383139,651081,51725,605836,755143,520393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]