SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578022 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578022 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577261,235423,212872,308403,626725,437862,531021,481356,348233,993794,739842,563030,963851,819718,226507,8571,514856,740910,732844,191257,335332,929395,692675,893553,711927,451960,246740,123679,289712,265151,599196,942758,489023,466898,553324,311273,393359,766556,481977,458773,320726,540657,676320,809383,300328,875597,492031,988706,938815,379971,263028,213708,325776,273532,401392,737564,459821,775132,523287,679217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]