SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 964671 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 964671 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42861,1040502,34008,180668,13954,1017971,841630,150656,1028004,114808,159435,767245,108766,136234,697378,128908,774637,155499,777957,1048795,475330,767770,897151,137669,567386,203235,235577,615036,543510,200731,120903,1036535,988347,407332,544604,381536,291388,835481,1001657,157515,423118,796537,737001,596018,288722,143140,157630,901660,197282,966534,530773,654710,599422,915866,867487,55147,1003954,848162,177863,991921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 964671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 964671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]