SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291228 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291228 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768680,1001963,929324,680677,759458,890133,36173,155701,318561,46348,160826,1023274,832741,387244,958817,129719,40330,89047,977635,536072,223338,664561,188450,976493,68354,131041,419800,151380,726831,990183,621703,128623,110504,882336,724957,397423,101502,65584,126222,853657,831626,915850,674271,929863,154011,721665,719798,670562,164030,864398,510071,168419,771891,823826,263511,942516,402602,616618,664819,598428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003505s ]