SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478982 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478982 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290338,610235,751768,19203,119316,1018523,110513,298942,473472,557791,850728,572160,345009,780704,267530,701604,153167,911996,972300,1041336,706680,11745,12561,529591,891295,848036,705883,605225,963934,599250,1041978,101793,852362,122500,796640,72582,819292,98182,229850,293166,1035069,592498,62863,96327,105997,653418,929310,884897,369184,922903,178227,767270,603732,69499,502798,1027311,430913,610141,738842,678135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]