SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 860918 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 860918 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368045,650664,1003288,180350,185344,544698,876553,349139,915380,641269,816095,147966,622725,961160,108320,740216,811266,92995,910391,2235,959707,126473,640303,588028,769023,836091,559909,269209,102764,431257,972064,29047,68620,871458,1019116,729794,550578,755737,850880,50977,84557,747155,93914,731859,104757,74325,495546,973940,46206,1001176,357650,400631,645109,70902,88080,301308,103676,72543,647463,1044033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 860918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 860918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]