SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539891 LIMIT 1 [ RunTime:0.000705s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539891 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636033,440370,342744,955477,937380,711737,967244,233681,516984,193399,551887,300960,565667,2908,536315,745332,72166,526447,381647,698550,824931,799774,320531,67131,167272,951386,150102,381329,651812,844562,420013,69989,364042,587141,975403,520197,943447,951085,53479,392760,713343,212075,523270,776797,686289,203469,827181,552703,608076,768027,401208,127494,1038970,574075,659918,25050,463543,1040277,949893,485060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]