SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 99913 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 99913 [ RunTime:0.002514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443529,76865,375389,521123,182051,300434,1035272,838029,51168,393961,25124,884817,464260,434109,700900,87711,915989,765222,106177,507940,627229,513884,573037,624605,272391,132894,352077,779732,815069,366282,853549,362527,561312,873961,1037568,714701,281776,109290,603556,718540,158178,1042254,169662,280742,259915,124022,991861,712652,1044365,699398,21004,883925,69777,636954,387498,336950,1041640,891325,539790,996820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 99913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 99913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001127s ]