SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280316 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280316 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801949,585644,311554,806456,736292,26498,987483,620604,523271,458786,69528,167781,714164,655234,608041,687698,316771,246203,434436,567483,232746,528468,838666,570302,658465,881836,772087,1032651,307594,497948,813288,183034,1001443,889236,750138,296260,448595,5720,581705,148113,305115,352770,498390,19185,872002,130611,1031195,402809,323834,514140,388706,128390,816003,537200,1042863,888084,752419,845584,765543,896619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]