SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020589 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020589 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484196,561696,206764,229091,702310,201849,638727,494435,788515,855010,420099,760820,395798,732271,894642,33793,1015978,678886,143853,831907,670536,82177,360118,498665,742404,1046629,996491,809393,361180,566366,254369,412423,412405,993431,481445,243593,629526,222118,352183,922728,1010026,453564,643553,416628,580875,364435,560521,187910,578933,702651,571191,895624,158704,558626,629108,365114,1040457,684928,698144,239851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]