SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505508 LIMIT 1 [ RunTime:0.001569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505508 [ RunTime:0.002393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140466,40279,861141,805731,966583,439317,733605,295275,703934,695037,467025,301639,296554,268802,502808,843405,1017566,795989,31161,322299,392996,449494,418466,253264,877448,920428,1043785,812719,592525,787347,463754,376569,625948,128201,912097,690143,280529,509519,634061,588353,891373,595929,613339,1039871,128294,1048598,218890,824568,62845,827392,663240,135310,62795,762134,178604,1022166,173475,52678,825881,193141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001624s ]