SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018822 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018822 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505558,991470,254091,54430,453889,422561,736220,225986,93137,209214,641586,622923,33902,253449,299461,432619,625453,760954,519539,433732,74855,622026,789903,937215,915646,422422,654110,132198,644385,752923,485883,51412,107216,430510,239927,272593,511868,174339,371752,601453,85800,39458,651247,210591,38288,1048719,971940,1031128,170839,871900,751629,921074,310806,939272,843905,336403,831311,431855,974235,796279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003539s ]