SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194452 LIMIT 1 [ RunTime:0.001016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194452 [ RunTime:0.003461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627435,1045229,98497,460328,339366,181878,699294,335917,834149,183590,349319,512661,998122,425005,1012496,190168,121195,985419,338137,319247,280105,278778,730594,797100,839914,667107,315048,502644,845314,186763,764416,622241,211005,184006,892768,828596,141983,999684,756076,237558,63238,1028189,752246,198924,536767,1040869,816994,530519,370828,170431,963468,636253,897697,901265,917416,793160,866789,391063,829791,746146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]