SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514110 LIMIT 1 [ RunTime:0.000642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514110 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282807,462525,91826,1041513,426355,794775,837408,74227,734613,120047,104981,582623,839840,64113,69261,94284,937708,990249,623125,371197,532312,783694,782731,314756,447969,200488,85267,689425,301000,1035916,335322,151184,110741,289770,178200,925884,969597,241416,568683,32649,513867,68157,1043054,568006,3878,172265,657309,474198,177115,85496,209496,87018,571670,390543,575424,576147,38143,1001477,789198,340269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]