SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418910 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418910 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878791,736379,987691,558864,1008693,310161,105404,208450,703040,24613,637175,505037,346580,413206,455740,748382,454830,227998,939650,198658,551118,724534,131775,451823,897409,403168,18531,811382,294558,439307,166649,970008,599466,370634,843560,863726,733664,613511,835910,744383,950986,461987,334115,404058,665499,779738,47288,228833,1032454,807287,832653,678241,51661,79403,774273,808864,890296,913779,854687,438450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]