SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383983 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383983 [ RunTime:0.004179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210472,512072,107494,858760,170915,102672,567771,23707,136119,934340,207282,249585,929383,334824,817133,902910,617689,987497,503560,307419,436495,218307,538591,53845,690293,19208,594760,1003865,50494,942826,874491,337133,981193,91356,8141,624158,808656,981382,504803,812858,146724,592573,410014,977808,258327,794799,114845,1010668,769531,579998,755737,163528,730428,366821,756618,561001,1020381,540431,517340,854942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]