SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281281 LIMIT 1 [ RunTime:0.001329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281281 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528784,459257,237117,335831,630075,407330,772449,723261,20816,300894,1022471,914102,607698,196960,195440,530405,597176,57080,49133,863454,504214,514156,834590,493413,861818,898784,195321,314491,801930,919332,812859,628508,813939,960752,585985,458398,238974,1016050,323068,576539,452185,93886,1041106,965324,579870,139685,996884,719436,295866,513373,722214,109738,342465,1029228,490035,886500,309666,5508,37427,25186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]