SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109821 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109821 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26278,208465,362213,939097,755634,248767,1048807,612821,446950,587786,976036,437245,713792,620011,889727,559671,290606,388458,944660,77827,186279,609243,964728,203505,394487,426761,275865,578392,650002,965537,711303,505508,79764,25887,423591,742925,201763,433704,55154,982691,661752,515978,770373,742423,657913,426585,110355,831400,5468,982191,446285,569243,755036,558299,747146,1025982,700080,591317,718251,438234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]