SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 763370 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 763370 [ RunTime:0.004209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584577,426139,132670,1028567,1046133,693385,52665,995587,677677,463178,355768,557950,1026866,946489,497278,918961,895110,1023122,155303,1023561,303830,70636,871031,476551,264525,112621,415450,600149,753479,483507,399345,766564,504126,709232,701570,736830,500910,984551,175149,537731,788844,860200,935844,351228,44428,414756,374735,996594,587830,480435,58171,548479,416388,98324,167858,641615,676808,209246,187826,787918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 763370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 763370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]