SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403754 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403754 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016724,579717,696466,190092,448912,906027,20504,418306,739186,110152,687103,703,705591,597005,174285,433893,38274,571038,798466,408121,1045938,754807,850543,680076,403924,391536,106852,483451,812491,909575,436259,470875,963975,847405,424416,1041271,1031690,357683,816439,94087,1035843,664127,287587,502609,1046628,961031,1007334,170480,414354,1011879,561170,219685,917635,923323,879863,14683,801012,1048082,553469,697167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]