SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52489 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52489 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31443,1020598,358793,600551,673706,80005,578255,354120,308906,482041,131483,287822,859365,220416,349226,508130,628224,938781,121763,607846,250359,736447,335580,717687,26582,992592,419931,667540,698924,1009439,444636,754433,918785,879288,592050,105887,816686,228128,646388,43798,944461,280777,242262,692171,62150,72225,405888,57203,662006,277105,52243,318065,581045,897334,734538,839865,1009377,738390,145319,300043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]