SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805409 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805409 [ RunTime:0.009787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359668,164817,408963,368183,201736,729003,554216,772720,124131,84693,283882,766958,95525,312574,972842,945306,535738,969999,130247,47315,548102,1009997,604861,724037,392740,642170,523384,678209,31401,728132,955547,136864,228180,232920,364792,910326,984210,861478,844384,43233,449453,15632,34026,181642,1024328,753674,167780,211305,415158,949974,60765,702459,790766,945637,736230,822379,992231,973920,834391,929521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]