SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319051 LIMIT 1 [ RunTime:0.000913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319051 [ RunTime:0.002829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405109,395311,243818,624713,683536,290482,965140,424794,140863,391623,874549,1003124,493393,421093,822859,293998,353394,506371,910345,503395,568914,839378,996950,621942,176435,871619,793299,352533,214997,223596,532117,361183,207086,248619,680517,372038,573300,422755,474442,450181,548262,390474,138447,123321,964627,686841,189531,442692,1027398,434894,611051,317805,423017,952453,6380,324880,97762,847282,441599,577168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001422s ]