SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140530 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140530 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103000,359177,475941,838073,1008346,355398,234059,964611,847998,70300,560868,834090,457014,545772,247200,330109,454480,235517,569210,865808,368264,259477,839958,555870,42771,533431,945928,1016642,383984,869042,283310,683699,757242,886334,838719,306517,485895,49211,497910,425295,684832,950962,907952,227734,161310,444455,443416,281798,664618,972928,182540,932547,670301,34393,865571,589757,132534,834481,582551,741321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]