SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416848 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416848 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206275,90898,286069,297826,961686,561591,839507,371550,656779,781940,673950,613465,225866,1035510,304363,617664,946483,165813,712179,437360,810052,1030886,881429,42619,742833,731275,440182,605213,770548,299082,343870,971710,1008414,848937,1019141,101179,962965,563761,231535,407003,231903,78616,594360,923032,902590,849982,185587,1001374,1045525,541431,627866,232260,375538,655762,849726,230293,311026,486444,790882,641822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]