SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425053 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425053 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623106,733104,321547,869738,719007,172977,952137,875152,92890,707180,224034,221356,442886,522195,359927,1025177,678578,195101,686487,271286,931292,306274,695934,1042327,354495,586427,47241,293990,954753,345998,573980,498147,104359,681712,991253,409839,769927,418167,583752,705905,498929,360113,325859,178688,176554,838645,629479,106637,227989,292524,737773,73559,622058,640898,360007,347859,347951,306302,858574,48099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005470s ]