SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536381 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536381 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49661,626372,66410,654140,673021,840791,939048,117905,643294,661485,169866,345412,942916,406679,671417,291772,114685,632899,1039155,21600,938620,437367,681792,305144,706204,998885,697566,710474,136810,245970,51754,215521,330138,256225,125298,999505,354163,849697,469068,741500,699856,768889,568194,445411,577328,592775,171284,875791,1023307,170192,537788,925951,923196,912886,174368,944875,220367,515129,780987,167544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]