SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294393 LIMIT 1 [ RunTime:0.003444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294393 [ RunTime:0.003439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278208,181182,555812,900691,860742,634384,575143,882985,171731,497256,993299,108651,126307,10618,1023359,677168,702745,352017,977144,1014434,464343,865767,499533,703270,891868,231998,945928,234845,521177,157301,579760,260628,115221,21201,157419,762066,747510,538660,535830,463279,1024644,719751,1035867,507899,810736,513398,963174,999459,789569,23597,488175,788850,470650,1028131,519860,725761,925778,417900,726151,963986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]