SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030230 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030230 [ RunTime:0.002946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846899,901202,612210,500163,600849,112057,555061,979976,1001700,1013098,893177,502873,788668,203405,69969,724769,51314,152394,89858,171530,151854,903486,92786,1010077,71148,538453,445944,651321,1033248,593556,375091,143975,300573,146892,606987,139527,896558,895174,126566,390133,842657,556956,470913,45004,822571,802219,321211,315458,495097,892541,857346,527684,455813,216913,498361,699958,513592,912233,730636,993262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]