SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804183 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804183 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209540,550507,261003,78343,628542,681980,644409,904078,424526,923332,282874,814794,511095,923399,416013,214204,63914,406724,183996,525824,606186,692233,37914,706445,853893,815652,891192,677131,548,58078,323566,714924,851811,291088,592575,1029111,347108,140641,1010593,7853,268252,755106,456908,410611,1004115,574790,1026198,682982,788910,516048,905640,654591,182515,880247,461689,911608,412041,502749,328267,553388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]