SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526180 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526180 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960296,612329,881328,452012,534303,754978,465285,439572,564001,848001,609014,213611,838486,743660,630733,381432,790642,54094,657722,770099,423035,465509,539449,920012,631966,29932,415109,388324,154668,161994,624482,701104,800365,465576,830312,136347,512652,177198,907192,711487,630243,32327,595157,25101,266131,560936,669406,495385,517782,249150,166508,960140,815552,383647,980175,557197,367902,587060,307079,819347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]