SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591540 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591540 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361602,1033066,271749,394753,79290,217961,474398,510001,747965,855583,516576,1024400,895363,880950,460210,151477,217241,694776,682284,609415,267955,848480,798396,926572,255715,221139,963252,451882,361566,464791,122667,971278,224723,818855,748209,618906,609520,905632,736377,162070,907517,362502,1045927,1002049,272681,163926,376779,87748,355500,200301,446656,750317,940435,110742,663626,189426,513434,791021,499524,977841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]