SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393183 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393183 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124027,161011,575332,139584,1016257,661487,187202,366227,180671,165947,616508,1043549,6384,717725,660125,379817,36282,932,902924,489299,316806,699001,923340,190771,278263,400096,551956,242040,331080,479598,59272,24676,245976,109336,413070,217551,162501,187842,1025735,459840,534939,964615,1021886,138311,944882,709832,123382,955026,126819,391227,853738,150234,919639,712233,107836,366857,82518,393839,1048742,939955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]