SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481892 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481892 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477811,90071,864280,1048356,390180,250778,866743,259804,467015,807386,282781,344314,368437,333440,452952,127825,389477,921800,165981,847781,293901,587092,280960,1038800,72035,690647,172832,50062,46190,894565,325461,815797,307028,988470,624064,745055,37015,447644,751431,781827,994051,281459,694256,23075,737839,353138,36427,402682,82906,790892,446719,262911,607579,125552,140008,546911,25548,306941,380604,283773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000837s ]