SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042150 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042150 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390430,613967,508174,60087,174322,526447,976461,318545,388262,724477,719100,181602,418737,138276,692986,834340,304927,648965,907680,319320,733007,413311,742240,19513,795669,861352,181547,423758,617681,506568,910241,656327,1039292,1003382,702718,778207,485363,819212,100937,449398,620649,1045209,245274,814077,278548,934387,902556,812381,648307,396444,833849,77179,1023134,550882,949656,354038,82683,831177,150090,547506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]