SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416117 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416117 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502919,204317,645962,546417,831163,746412,23816,461533,113680,419815,445303,386009,270739,743689,1040813,47392,834971,977926,548348,163627,479007,1043892,625244,155551,462506,324278,961933,432533,272432,395153,285549,1011105,17646,165592,892088,341274,380279,922260,376898,776297,117372,345113,492906,513127,515513,923926,773880,284553,841676,694742,15499,904400,424436,663211,595418,325404,246134,439841,287394,506158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]