SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545407 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545407 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280969,641162,705826,133359,909710,239678,476840,559188,539302,411136,541449,643815,65871,91339,635690,831794,103474,870738,804222,933019,183472,511280,501767,875624,84137,289221,653292,737221,455883,145776,252738,863653,804842,288070,459607,63316,396502,486933,998221,832115,472774,271721,391030,140667,70013,490043,1005597,574451,865331,801537,799295,847889,503771,445307,290997,603577,529185,626585,37620,15013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]