SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419029 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419029 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023852,234081,146702,609968,460918,623229,328007,630524,333491,455385,810292,73995,26936,30572,34849,473168,175860,154533,582993,841666,384544,794996,931647,183916,280423,526210,407728,700805,390943,62679,1016841,459907,525679,929966,844680,18564,899016,129421,850501,717409,547156,573841,360588,979164,593313,917104,999973,878947,117956,928415,240191,285571,729234,875561,67036,494591,663139,361212,705884,217696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]