SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541920 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541920 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660073,624706,583937,396386,738040,17707,383111,692102,406467,902958,967330,575831,338224,936968,466093,321545,503066,520292,102396,898589,467036,953445,750212,845636,734710,804410,511415,259337,824283,602143,484748,814224,539455,763120,7182,985985,327184,1010647,723491,598808,155389,101095,130029,592123,615142,873486,394937,644067,1000287,397370,543996,320646,356920,220982,271260,35982,159830,140515,662905,52342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]