SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205814 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205814 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287592,471888,1008741,465111,842581,619443,966440,474482,877445,165541,275997,840184,19070,411738,193066,442166,167134,797793,315120,322896,887342,489274,691187,672934,234111,1038391,674840,456357,867479,879778,946840,705056,702683,100217,195432,447323,334146,371510,606648,173549,85509,566587,333223,726127,971187,651580,91356,361774,33043,175310,917197,112459,508902,929129,142212,229908,1009235,517458,794565,776545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]