SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479110 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479110 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289045,1036367,11983,285637,767284,495183,883199,693336,668716,574081,636595,194826,292149,889327,119191,727729,710854,471740,410554,239790,948188,448041,980619,459892,921517,481013,127783,528527,1000810,488615,776976,189974,416684,741672,911334,437817,864095,358084,805104,606072,618333,1024184,694162,397107,551094,346221,783958,1023680,334233,351565,546142,506666,581969,607145,1024834,275320,890236,1045282,916233,584566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]