SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012404 LIMIT 1 [ RunTime:0.001852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012404 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419362,784445,917649,102366,835342,54475,36299,788810,138523,130804,94333,193274,869492,1021412,687801,57321,533472,1027372,23773,423824,572851,640452,44797,520335,124360,379083,731288,438000,785434,311180,127116,958931,33403,972990,886818,238634,37756,282145,428149,283639,917464,404797,380048,661178,646309,771887,961900,1444,958121,596949,834105,422089,271653,447210,392965,9396,118771,392573,514709,651702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]