SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542482 LIMIT 1 [ RunTime:0.000658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542482 [ RunTime:0.002948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49814,622639,358612,990440,674959,612539,322789,753924,246551,833257,149734,750973,906800,764155,70252,990090,207359,325658,669152,726566,971253,316397,641207,283063,442784,796172,864255,528654,129343,181455,128750,659658,730603,175878,680262,580316,803510,394879,488862,1508,308429,763122,94607,145283,1026513,418720,920141,654928,401307,579242,861882,482762,47917,1005421,481102,947468,706460,860482,81682,985557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]