SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806823 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806823 [ RunTime:0.002745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719836,646672,558100,285774,731405,890015,811966,422445,612152,658182,920908,68461,819726,720295,174888,325758,380809,271007,833876,605965,271184,141532,251168,665910,471700,908834,268643,847339,1017015,186107,929102,467703,450589,162416,828879,49725,721004,895822,316954,895609,872733,481715,811917,978533,161502,528324,126634,82284,271032,1030285,826678,829840,1026472,374267,561879,891022,518438,748428,844617,510643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]