SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286243 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286243 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179886,89209,364632,223241,660405,685658,269541,181728,490562,676049,614726,928091,635278,551144,483992,927438,251740,265023,260956,898947,658834,698970,734290,107703,147471,727954,682285,362228,4024,57287,157961,164803,270531,3918,440637,450330,599329,785504,560927,772327,96162,149855,292069,578681,577392,517655,176361,363694,521739,283845,580170,317335,937449,964088,945525,253656,255176,697549,454631,263054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]