SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475295 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475295 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988660,685118,462734,651597,419990,1039685,185457,909919,702549,648486,821728,603516,980765,619395,474422,300897,545703,989277,67902,275246,638512,126507,879683,560932,579862,700430,570292,305172,547763,257556,908598,328415,408603,903248,384284,301683,314160,345970,468813,685564,185893,706642,729622,840173,312620,138567,389116,991331,1046749,630646,823580,627561,998615,484794,133997,603398,115575,313262,733440,306499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000888s ]