SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412090 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412090 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528991,680303,953209,915347,906656,730737,1032230,528026,1029498,982179,147891,437985,204358,60631,31439,494214,28044,283102,39665,637231,775201,387842,611409,408514,506998,415993,662610,483567,848440,416309,635262,109783,171917,802569,983271,199227,964684,913780,347370,722459,202226,1025555,457188,438169,429051,731732,909101,343082,389790,196004,668842,739370,899925,655844,450783,360775,437172,308390,615676,552641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]