SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402882 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402882 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489894,782927,193512,615,956569,542479,1014194,674911,96086,158509,600086,377842,1019599,511795,873527,376013,305802,375548,708801,810026,829803,446260,20125,521421,45690,114382,838850,1008648,10934,565053,339087,829775,946464,307047,878750,806541,70805,587252,615879,175199,247619,556552,576125,833302,598891,627757,651202,638690,257291,432015,420003,321154,341678,518683,939967,646066,86168,933275,656166,441171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000825s ]