SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550842 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550842 [ RunTime:0.003209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468595,411518,153541,1025552,1028792,333309,699684,899884,1020610,570943,988811,458614,38016,483755,168987,973542,613911,492740,369532,693353,353897,702675,484137,255253,120002,416908,1023470,663046,876357,146112,573333,195268,36913,295444,726224,975400,229120,866327,277848,988721,516220,576619,895570,43160,74088,128365,1033853,160929,224213,879614,120120,1024536,890496,20723,699342,80236,619123,190475,448611,355978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]