SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469312 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469312 [ RunTime:0.007978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160570,972574,545262,316441,199728,827935,405388,750138,551121,1042941,1016084,973474,375127,889137,188005,959369,183128,244208,365097,849939,160496,948109,76653,855499,243931,585666,864531,727016,48659,3802,392788,125540,585653,647522,471769,880536,685789,368979,634515,116745,980229,45387,697506,254767,140921,471864,470751,853767,595721,574919,707640,203734,251120,468157,456909,217521,415778,966198,657202,929033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]