SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527040 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527040 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734822,568782,162382,776048,410628,489613,174496,547948,685142,662793,236431,925973,259709,544874,409628,139751,658483,778500,314511,770540,682060,150376,910346,243225,329100,70867,236676,1015262,855849,179127,294168,978736,161848,873129,932046,538636,174518,395495,928953,193090,643543,751863,63255,404492,204887,50094,858901,89506,366275,66833,412684,927267,27362,647756,108545,183545,1012437,334129,669600,231798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]