SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543975 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543975 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347790,244050,515276,872253,795985,289291,232560,390007,1020112,997006,140844,618710,769321,892537,357743,820315,686991,804750,919764,916865,147956,787650,849873,828790,254129,971603,1044400,984948,552900,348651,390924,912140,852125,272315,274530,918301,978749,65020,142674,299565,41285,365205,96213,647048,395853,1000355,354475,334996,887933,200824,1007069,611883,979835,557688,231510,844672,489501,303261,205975,732215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]