SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253509 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253509 [ RunTime:0.005925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784824,885128,139780,117538,712294,181723,651624,492961,429861,31529,994027,170591,110072,57629,534251,594815,606237,52460,465131,484566,745025,107508,845148,593028,786397,628109,305244,664069,168661,256452,119024,934259,788305,563764,225212,342844,725280,329945,243359,601053,470580,809093,525348,92485,706484,447752,631918,66633,139502,550038,255047,530641,851037,419339,986007,975041,1032119,940119,357213,125596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]