SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541244 LIMIT 1 [ RunTime:0.001314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541244 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019641,210761,424864,895325,804373,368130,592992,143068,301804,980947,80131,55856,540759,356330,416778,429290,427938,152365,908222,758140,321995,575528,333264,272613,506610,458965,13651,181385,972760,132409,333318,958112,543955,353086,902772,597011,946365,377590,823249,674845,490749,337565,558195,458331,764501,894648,154332,855162,803709,911467,779039,516435,536323,784437,297934,327115,97808,656154,611267,522365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]