SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017236 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017236 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118292,54220,783717,535451,286129,153587,110753,114834,626322,342558,357197,765183,534467,623643,962427,691033,182777,54633,567736,471665,249403,320484,316462,976755,417363,539522,124485,664227,103183,538088,485898,811707,909409,731972,1016331,662207,159781,109782,954980,169471,666179,571041,877272,902586,897539,972744,97646,778868,39207,338067,842507,517046,518702,567418,685300,760458,702421,64221,1024614,704867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]