SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44041 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44041 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606308,19811,724262,241752,119652,379124,550300,691602,60612,76654,895925,348772,732117,679778,349454,78066,422213,656337,987548,369175,833250,976065,55898,926484,660130,747968,841409,1005140,486031,475807,312628,491364,749499,705638,428650,873250,482835,164012,51023,608348,51480,437330,463168,679900,741376,528728,589638,385978,783817,801866,654789,475080,42226,526679,166585,21413,1046792,584157,573343,851069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001167s ]