SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432160 LIMIT 1 [ RunTime:0.001057s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432160 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591102,640249,240894,458709,1021549,641677,672048,89502,407947,964320,69393,970847,1000055,766419,357535,872200,632456,1020609,146651,551917,241105,974431,608488,298826,713929,529441,86498,901625,543283,172808,671901,758192,295254,163693,342628,651436,452558,1043779,33995,88290,996803,605833,482494,1028786,224931,879997,671785,200665,143858,146357,331129,474846,543965,207244,463017,83755,817144,908080,394550,49531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]