SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513763 LIMIT 1 [ RunTime:0.002687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513763 [ RunTime:0.004739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315170,273340,548306,194239,889210,141639,481000,73647,726022,13,262246,130537,271010,761245,878371,170133,47461,59046,577992,414360,1048510,507040,366403,10650,733361,856635,562686,971060,406439,133756,555917,759539,274375,566053,898202,335986,88824,415159,797978,349939,905901,631356,97420,404115,206036,488134,386127,317348,554728,973907,532274,202659,780660,17144,88341,383311,81943,713834,450692,205122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001152s ]