SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043890 LIMIT 1 [ RunTime:0.001125s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043890 [ RunTime:0.003925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209598,900793,268119,778356,988543,385819,153257,842472,982775,344338,31463,561881,340257,546991,487473,498704,126115,679313,582541,422882,219330,912834,462100,298214,545233,596174,109997,115837,796626,327100,546215,98614,417552,300879,57813,287885,88508,295270,560365,647183,287848,654413,310735,965160,1031789,910294,374869,895169,301165,212764,709748,955946,292808,489293,142316,250082,841601,898472,374862,571793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]