SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313686 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313686 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801496,403252,313460,26988,853480,814020,340351,932596,2149,687754,941159,141385,477269,990295,262823,520406,285892,355183,1009631,62608,258429,823441,286996,726683,544566,944062,555915,575120,353615,411352,14060,188164,784144,1037670,892936,688354,91731,515382,453871,576217,826925,854240,140470,710364,190320,992184,377501,189392,281851,833582,886467,7102,192788,442316,604679,555800,1046825,915899,111770,130554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]