SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002780s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499522 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499522 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171701,562838,815012,213161,807906,203565,283339,460901,829301,578472,686582,154954,702303,363573,174689,285443,354940,798956,933759,477294,780062,1004821,198427,229428,670779,114932,867447,463216,199741,196865,117304,980762,751792,534777,456314,560167,867893,839043,81239,973382,178459,145234,711699,910768,1048710,412287,392768,478884,130078,503419,148706,710250,854918,658163,986142,501440,888229,684469,416896,972995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]