SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 82514 LIMIT 1 [ RunTime:0.001041s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 82514 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994039,270555,590778,673305,249294,486772,320378,942997,116727,960326,49942,357861,270034,65546,655583,1038187,654799,94204,516656,177443,126578,754033,773118,697315,826574,919627,290457,858614,628131,1004102,177080,384571,638854,662859,404234,234035,142547,581744,248404,561037,453651,430143,541464,975788,622443,402823,273749,558110,76946,908380,1020264,678209,452826,528289,236312,157154,33343,20870,16882,812024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 82514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 82514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004775s ]