SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580017 LIMIT 1 [ RunTime:0.002434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580017 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036086,857105,250519,1027580,317816,580327,780801,156088,956896,858455,309110,868635,192385,300644,326822,248953,945239,594865,229555,186172,451844,46342,40583,431256,356233,280157,861321,78181,603559,616232,279434,305231,631334,918749,77346,943152,355066,2373,712895,500671,398671,329253,998331,919398,110797,416978,215521,802475,79624,818229,970293,690473,864831,146295,689727,316113,639987,1026298,843726,641632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001501s ]