SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436529 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436529 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243677,742267,496036,396443,618414,80623,408921,45756,166005,187095,305688,564615,361779,50729,476917,211487,219270,977175,637243,21414,236860,1035292,52028,964705,479561,896535,577821,1034588,611077,44419,635049,648688,409442,150089,36327,796967,502948,795316,116488,1012678,742828,733200,139792,914692,681425,225437,285303,383409,482617,605309,884889,839735,550924,437990,185471,981817,991275,91000,75748,743434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]