SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544519 LIMIT 1 [ RunTime:0.000801s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544519 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514800,475827,503439,523646,743031,296005,626096,155975,413118,411291,670412,399226,861427,431234,119156,870329,330623,960512,343679,802966,773706,1015636,429626,266528,158026,610979,528886,922412,67598,439678,120816,754154,754711,54480,128618,402674,757281,740996,888119,686356,779142,902604,879977,838715,149244,1017463,33102,913879,380087,394887,928837,853126,41261,617345,261870,463151,365114,106291,598039,150428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]