SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260630 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260630 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505463,851129,720563,179676,599191,378236,492127,268580,626892,406656,201570,969557,731852,1021924,461463,879741,629223,267794,747676,777249,695799,277120,103330,981104,593233,477997,643523,815911,668455,265108,918812,163262,1019987,49081,658622,978177,286552,116321,521782,953258,991193,339132,786088,643823,274298,31164,909856,694703,248869,260366,786904,566694,526059,1008251,993555,445815,506421,893711,293601,668201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]