SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438308 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438308 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3374,631229,171401,758712,492381,132278,676175,972366,343543,904628,393417,856887,561885,498509,187525,662997,11174,460662,92624,72578,594404,174697,1016791,10657,842486,191795,2646,339168,96100,663423,142870,873867,64477,660933,920811,287957,1040594,602431,205263,759238,116769,1008688,1027591,970954,442023,102943,896704,629638,862904,497628,1006214,186395,536917,661207,447926,452863,67690,567622,619205,230243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]