SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004563 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004563 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47781,926177,1046636,743988,457093,91543,839539,800454,734530,928559,474139,625119,241670,523060,1022167,218738,594183,951059,592006,303415,463309,404575,714811,828102,54395,765058,260,790583,525527,705734,705807,424491,967013,913636,342183,575368,11464,735618,571390,476415,270102,80467,966398,1014717,829158,970156,511684,428647,1025376,92172,361169,665919,1019205,991577,387303,867866,201614,339659,479175,959624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001934s ]