SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003911s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801080 LIMIT 1 [ RunTime:0.000649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801080 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181095,287416,44862,993,188055,441088,711093,144048,84851,936668,490311,558810,451385,146937,767370,258626,148418,278971,154320,81882,1041599,37431,460653,548788,71536,938814,245099,747390,384935,63833,489896,207153,540004,190456,589062,17267,265526,802896,997966,965481,908501,619789,961435,770901,824908,658356,561282,700605,1004320,899551,353047,655971,937749,576457,241016,54975,57716,277928,1033960,1028582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]