SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 155213 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 155213 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181254,700710,50375,268496,216995,108254,666914,394279,157879,894254,776675,686323,138450,880176,730596,1013306,396430,532803,809002,177417,821227,291334,868444,667570,455053,54967,330007,1011059,679153,806757,207315,939655,826889,390426,813943,972480,936962,913879,561293,801799,119693,922382,794545,527441,793273,796475,768134,609973,911684,681150,538625,771661,706070,18224,572149,395550,944805,1020776,621465,564024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 155213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 155213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]