SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414969 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414969 [ RunTime:0.007064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913532,452525,807275,107626,49518,306014,388371,248510,110874,348537,251831,789345,269536,75352,100305,709057,631608,177306,473230,671798,1038330,443935,932500,160174,722992,619330,893518,913543,718167,13037,590082,205663,646959,11618,986779,525754,677476,598338,650447,717343,15592,379219,345846,257411,588958,714238,22587,992890,346988,973964,1010490,202428,542266,435571,214999,243937,863929,382503,245524,143657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]