SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516493 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516493 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047770,395770,357664,745279,833894,652584,725863,803248,942382,227650,494199,547533,580677,260160,506333,849460,901137,700086,259953,272927,845025,335475,383064,349719,860507,698917,837233,1011116,370736,882079,175989,1027023,955295,970827,206752,323629,871681,727165,882058,280988,465132,159151,363619,629106,837916,740878,202964,726595,729214,772712,814197,641761,679365,875732,480206,1041960,326589,689612,994209,213151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]